﻿CREATE TABLE [dbo].[vehicle_type] (
    [id]                INT            IDENTITY (1, 1) NOT NULL,
    [name]              NVARCHAR (MAX) NOT NULL,
    [id_main_fuel_type] INT            NOT NULL,
    [type_vehicle]      INT            NOT NULL,
    [heater]            REAL           NOT NULL,
	[qnt_passenger]		INT            NOT NULL DEFAULT 0,
	[qnt_total_passenger] INT			NOT NULL DEFAULT 0,
	[del]   bit            NULL
    PRIMARY KEY CLUSTERED ([id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

